<?php
/*
    This file is part of EnvoiMoinsCher's shipping plugin for Joomla VirtueMart.

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.

   @author Boxtale SAS <contact@envoimoinscher.com>
   @copyright  2011 Boxtale SAS
   @license    http://www.gnu.org/licenses  GNU Lesser General Public License (LGPL)
*/
if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' ); 
 
  require_once(dirname(__FILE__)."/../classes/shipping/envoimoinscher.cfg.php");
  $code = $_GET['code'];
  if(ctype_alnum($code))
  {
    $db = new ps_DB();
    $query = "SELECT order_id FROM emc_orders WHERE code_eo = '".$code."'";
    $db->query($query);
    $order = $db->loadAssocList();
    if($order[0]['order_id'] != '')
    {
      foreach($_GET as $g => $get)
      {
        $_GET[$g] = urldecode($get);
      }
      $fields = array('order_id' => (int)$order[0]['order_id'],
        'state_et' => $_GET['etat'],
        'date_et' => date('Y-m-d', strtotime($_GET['date'])),
        'text_et' => mb_convert_encoding($_GET['text'], 'UTF-8'),
        'localisation_et' => mb_convert_encoding($_GET['localisation'], 'UTF-8')
      );
      $db->buildQuery('INSERT',  'emc_tracking', $fields);
      $db->query();
      // case when order was shipped to receiver
      if($_GET['etat'] == 'LIV')
      {
        $fields = array('order_status' => 'S');
        $db->buildQuery('UPDATE',  '#__{vm}_orders', $fields, 'WHERE order_id = '.(int)$order[0]['order_id'].'');
        $db->query();
      }
    }
  }
die();